Credit Manager

Access to the Credit Manager application can be granted via the options on the Navigator Menu.

The process for the granting permission and access is essentially the same for all three of the Navigator menu options. The following example uses the Navigator Control User File Maintenance option (NAV 5).

Use the Web Access option to grant access to the options included in the Credit Manager application.

On the next screen, enter an A to grant or deny access to the Credit Manager options.

Enter a Y to grant access.

When the Credit Manager is accessed, the Dashboard displays all the orders on credit hold.

For detailed descriptions of the fields on the Credit Manager Display, refer to Credit Manager Display Field Descriptions

To help you make an informed decision on whether or not to release an order from credit hold, the following information is available by clicking on an order:

• Accounts Receivable
• Order Details

Selecting Filters

Creating Display Views

Exporting to an Excel Spreadsheet

Selecting Filters

Filters allow you to make your query as general or as specific as needed.

1. To access the filters, click the filters icon () on the right-hand side of the window.



2. Decide which parameters you want to omit or include in the query.

The following example shows an inquiry based on a date range for a couple of accounts.



In order for an order to be displayed in the Query, it has to be within the specified date range and assigned to both accounts.

3. To add another set of first values, unrelated to the first, click Add a Condition. A search will also display these results. In the example shown below, a Condition was added to also include held orders for the first month of the year for a specific company.

   

4. Click Apply to refresh the query to display the results based on the new filter.

5. If this is filter you might use often, click Create New Filter.

6. Name the Filter and decide if it should be Public (available to all) or Private (available only to the person who created it).

   

7. Click Create to add the new filter to the Public or Private listing of filters.

Creating Display Views

Views enable you to add only the information you want to see to the display.

To access the views, click the view icon on the right-hand side of the window.

The figure shown below shows a view built to show information important for orders.

• To add or remove fields from the view, simply click them to move them between being included and not included.
• Drop and drag fields within the view area to change their positions on the display.
• The Default view for orders on credit hold includes all the fields except:
  • Account#
  • Branch
  • Salesperson
• The Apply View button updates the displayed data to the fields included in the view, but the view is not saved.
• The Update View (for established views) and Save View buttons save any unsaved changes.

Exporting to an Excel Spreadsheet

Click the Export button to automatically create a spreadsheet containing all the information on the display.

Click an order to access links to AR information.

AR Summary

AR Ledger

AR History

Notepad

AR Summary

This information comes from the AR and Open Order Systems. It shows the amount of credit currently available to an account and the amount an account is over its credit limit, if any.

For detailed descriptions of the fields, refer to AR Summary Window Field Descriptions

AR Ledger

The AR Ledger Screen includes the main inquiry options for accounts receivable. From this screen, you can find each account's current balances as well as aging and all open transactions, or those paid or closed in the current month.

There are five options at the top of the window:

• Show current paid items - Activating this option includes all invoices that have been paid in the current month.
• Roll credits - Activate this setting to roll credits and apply to the oldest invoices. If this setting is not activated credits are allowed to age like debits.
• Include ADs in AR - Activate this setting to include the effect of advance deposits on all AR ledgers and reports. Unless advance deposits are tracked separately it is recommend that you enter activate this setting.
• Aging option - The default option is the setting for the company. You can override it to view the AR Ledger via other aging options.
  • Options 1 and 2 represent the actual age of each open item. Options 3 and 4 are based on due date, which represents the past due date of each invoice.

Default aging options are assigned via Option 2 - AR and Credit Options on the Company Settings File (SET 3).

• Age limit - The age limit field relates to your aging option. If the selected aging option ages based on invoice dates, then the age limits are based on invoice dates. If the selected aging option ages based on due dates, then the age limits are also based on due dates.

AR History

In the Company Settings File (SET 3), you can set the AR History File to store between one and 99 months of history, but the default is set at 24 months. We recommend a 24-month history unless you have enough free disk space to handle more. Also, note that the AR End-of-Month Close final step, Reset Files and Officially End EOM removes old history records. Open transactions are not affected, regardless of their age.

Most of the fields are self-explanatory.

The Paid Transaction Codes can be system defined or user created via menu option ACT 112. To see a complete list of all the codes, run the AR Transaction Code Report (menu option SSC 237).

Notepad

The Notepad window is used for storing notes, comments and other text related to a specific accounts receivable account.

To add notes or change existing ones, click Edit.

Users have to be given permission to access the notepad through the Allow Access to AR Notepad option on the Navigator menu (NAV 1, 2 or 5).

Contact Information

Special Instructions

Notepad

More Options

Contact Information

You can use this option to store different types of phone numbers and Internet connections. Click Update to make changes to the existing contacts.

• An Area Code is required for number types F and T.
• There are two ways to enter email addresses.
  • When entering email names, 18 characters including the @ symbol can be entered in the Phone Number/Email line. If there are more than 18 characters, the additional characters can be entered on the Description line.
  • Or, you can enter email names up through the @ symbol and then enter the URL on the Description/URL field.
• The Extra Digit is normally used for fax numbers. You can program certain digits to always be dialed before any fax number. However, if you have 10-digit fax numbers that are considered local, and they cannot preceded by a 1, you might need to use the extra digit field to designate which numbers require the 1.

Special Instructions

You can use this option to enter special instructions for a customer and to note instructions that should be printed on an invoice, pick list, purchase order, order acknowledgement, or quotation. Printing special instructions and product information can greatly enhance your service to your customers and help your staff to be more responsive. You can use the Special Instructions to:

• Print a customer's packing or delivery requirements on their pick lists.
• Print a special greeting or message on a customer's invoice. The message can be specific to that customer.
• Print information such as special codes and numbers on customer orders and invoices. Some examples are DUNS numbers, accounting codes used by the customer's accounts payable department, and blanket POs for government accounts.

Use the Sub Type to indicate the language of the text, for example F = French, and S = Spanish.

Notepad

Displays the Billto File Notepad Screen screen which allows you to enter additional information regarding the customer. You can insert as much information as necessary to this account.

More Options

Click this option to access even more information from the Billto File.

• Marketing Programs - Each account can be assigned several marketing programs. These can consist of company trip programs, co-op advertising programs, or can be codes that designate that the customer is part of a group of customers that you need to track in a special way. For example, you could assign a marketing program code that identifies all customers that belong to a certain trade association. The system then automatically tracks composite sales of all members of each marketing program.
• Display Types - See the major product displays and sample sets associated with this account. This enables you to track which customers have which displays or samples, and to analyze sales for customers with and without these displays.
• Salespersons - You can use this option to assign a salesperson for each item class, manufacturer and cost center. Use this option to enter salesperson assignments only if you assign multiple salespeople to a single account depending on product. If not, assign a single overall account salesperson in the Salesperson field on the Billto Profile screen.
• Price Exceptions - Use this option to review and update promotional and exception pricing. You can change a customer's default price list for specific items or groups of items. You can also display promotional pricing that the customer is eligible for and the effective dates of those prices. A pricing exception is a price list number or promotional program other than the customer's regular price list number assigned on the Billto Profile screen.
• Tax Exemptions - The Avalara Tax Usage code is displayed. This provides the same functionality found in the Billto File - Tax Exemptions screen. For more information, refer to Avalara Integration.

This tab allows you to review:

• Order Details with an option to view the complete order
• The order Notepad
• Order Dates and Times
• Any Invoices issued against the order.

Order Details

Notes:

• The Warehouse shown is where the inventory is being shipped from or picked up at.
• The default Supplier number is 001 which indicates our inventory

Hyper links

The following hyper links are available on the Details window.

Accounts - (in this example account# 200888) - Click this one to access additional information on the account.

Order Number and View Full Order - These links take you to the order in the Navigator.

Item Links - Accesses additional information on the item.

Notepad

The notepad is where you can enter notes about an order. The system also automatically records events such as line status updates, quantity changes, and price changes.

Order Dates and Times

This section displays dates and times related to the creation of an order.

Setting	Description
Date Entered	Date and time the header screen of the order was entered. For EDI orders, it is the date and time the EDI order entered the system
On WS	Special Workstation Codes !G - Navigator Order Management order !! - Decor 24 order !I - Order was generated in Image Builder !S - Order was generated in Selection Sheet Manager
Date Processed	The date and time the order was assigned an order number and processed, but the order was not necessarily printed. If the order was originally a hold, this could be a different date than the date the header was created.
Entered by	This is the initials and name of the person who keyed the order. If there are initials, but no name, then the name is not defined in the Classification Codes File.
Sent To Credit Hold	This is the date and time the order was sent to credit hold, if it was sent to credit hold.
Released from Credit Hold	This is the date and time the order was released from credit hold; if it was released. The initials or authorization code for release are also shown.
Primary Salesperson Secondary Salesperson	The Salesperson initials are pulled from the Salesperson field on the Order Header screen. The full name is pulled from the Salesperson File.

Invoices

This section displays the first/oldest invoice associated with the order.

If there are additional invoices associated with the order, you can click on them to view their details.

Users have to be granted access to invoices via the NAV menu.

Click View Full Invoice to access the complete invoice in Navigator Invoice Inquiry.

Sales by Item Class

Month to Month Sales

Field Name	Description/Instructions
Gross Sales	Includes the total amount billed on invoices and credit memos, excluding tax, freight, and discount/handling charges, which appear separately at the bottom of the invoice or credit memo. Miscellaneous sales (entered in miscellaneous F6 lines on Order Entry) are included or excluded based on a company setting that is set when the system is installed.
GP $	Gross profit; gross sales (as defined above) minus the cost of goods sold, as it appears on the invoice registers.
GP %	Gross profit percentage; gross profit divided by gross sales.
Avg. Order	Average order; the total amount ordered divided by the total number of orders. Order size does not relate to Gross Sale $, unless all of the orders were invoiced at the same time. This screen could show an average order figure and zero for gross sales if the orders were not invoiced. This figure represents the size of orders, not the size of shipments, which might be, for example, out-of-stock or split deliveries.
Avg. Line	The total amount ordered divided by the total number of order line items.
Fill%	Dollar amount shipped divided by the dollar amount ordered. This shows how well you fill the orders you take. Fill% is calculated at invoice time, by taking the amount shipped and dividing it by the amount on the order, not including back orders. A Fill% of 100% means you shipped everything that was ordered. Over-shipments are calculated as complete shipments. Fill% can never exceed 100%. To increase the scope of the Fill% figure, you can enter orders for out of stock goods. Normally, you tell the customer you are out of stock and not enter an order that you could not fill. However, if you enter the order and invoice it for zero shipped, you'll reflect the missed sales in ordering statistics and Fill%, which represent the true demand for each item.
# of credits	Number of credit memos issued, including debit invoices that include a credit, such as for a material exchange.
# of orders	Number of orders issued. Orders are only considered issued if they are printed or processed. Temporary holds of inventory are not counted as orders until processed as orders. Don't confuse number of orders with number of invoices.
# of lines	Number of order lines issued.
Cred Issued	Dollar amount of credit issued, including credit memos and credit lines included within debit invoices. Credit lines can be entered in debit invoices when customers are exchanging material.
Credit/Ord%	Also known as the Rascal Index; the ratio of credit memos divided by the number of orders. 10% means 10 credits are issued for every 100 orders.
G.P./Order $	Average gross profit dollars per order; an important figure; the total gross profit dollars of orders, divided by the number of orders. This figure relates to the Avg Order$ field, and does not necessarily relate to sales for the same period. It is a measure of the profitability of the orders you take.
Oper. Prof.	Operating profit amount; equals gross profit amount minus the cost of processing orders. The cost of processing orders is the number of orders times the average cost per order, as defined in the Company File.

Sales by Item Class

This option displays a customer's sales and gross profit percentage in each of the main item classes that you have established. This relates to the Item Class 1 field in the Item Master File. The window displays sales in the current month, past 12 months total, and the previous 12 months total. Enter X beside any item class to display a 24-month sales analysis for that customer and class item.

 

Field Name	Description/Instructions
Item Class	Classes of items sold to the customer. Only classes that have had some sales or orders for this customer are displayed.
Current Mth	Total amount sold this month for each item class.
GP%	Gross profit percentage of sales this month for each item class.
Past 12 Mths	Total amount sold during the 12 months before the current month for each item class.
GP%	Gross profit percentage of sales for each item class.
Prev 12 Mths	Total amount sold during the previous 12 months for each item class. Previous refers to the 12 months immediately prior to the past 12 months column.
GP%	Gross profit percentage of sales.

Month to Month Sales

This option displays a 24-month sales analysis for the account.

Field Name	Description/Instructions
This Yr	Lists the 12 months before the current month.
Gross Sales	Lists the gross sales for each month in the past year.
GP%	Lists the gross profit percentage for each month in the past year.
Avg. Ord	Lists the average order amount for each month in the past year.
Last Yr	Lists the 12 months before the months in the This Yr column.
Gross Sales	Lists the gross sales for each month in the last fiscal year.
GP%	Lists the gross profit percentage for each month in the previous year.
Avg. Order	Lists the average order amount for each month in the

This option lists all of the Ship to addresses created for this account in the Shipto File.

Use the Shipto File to create and maintain shipping addresses, phone numbers, and shipto numbers. The Shipto# from the Shipto File can then be entered into the Default Shipto# setting in the Billto File to provide default shiptos for the account.

There are a couple of ways to release orders from Credit Hold.

Releasing Multiple Orders

Releasing a Single Order from Credit Hold

Releasing Multiple Orders

On the Dashboard, select the orders and click Release Selected Orders.

After Release Selected Orders is clicked, the orders are removed from the Dashboard and are not on credit hold anymore.

Releasing a Single Order from Credit Hold

From the Dashboard, select an order by clicking it.

Click the title Update and Release Order near the top of the window.

The window expands to show the following input fields.

 

Field	Description
Authorization Code	The person authorizing the changes to this account, normally the person's initials or sign on name.
Color Code	You can color-code credit held orders, so that they appear in colors representing different hold status, such as waiting for check, waiting for delivery instruction, or do not release. To color-code a credit held order, enter one of the following codes in the Color Code field of the Account Review screen.
Credit Manager	This setting lets you shift orders shifted to another credit managers' screen without changing the BillTo File credit manager field. If a credit manager has the screen set to only show orders for a specific credit manager code, the program displays orders that belong to accounts with that credit manager code, and orders that have been overridden to their credit manager code. Therefore, orders whose credit manager codes have been overridden, display on screens set for either the original, or overridden credit manager code.
Terms% Days	Lets you to override the discount payment terms. For system defined terms, enter the number of days (in parenthesis) in the days field.
Code	The terms code.
FP Account# FP Terms	The Floor Plan account and terms. Credit managers can change an order to or from Floor Plan by updating the Floor Plan Account# and Terms field.
Ship Date     Recalculate	The Credit Hold screen lets you to clear the ship date and force the system to retrieve the next ship date. This should be done by credit managers when an order is held long enough to impact the ship date. When you clear the Ship Date field, the system retrieves the next scheduled ship date for a delivery, or inserts today's date for a will call/pickup. The date can also be overridden as needed. The User might want to recalculate the ship date if the ship via or truck route has been changed. Another reason is that the order has been on credit hold long enough that the original ship date is no longer valid. Click the Recalculate link to change the ship date to the next available ship date.
Collect$	If you want to collect an additional amount on an order entry, enter the dollar amount here. You must enter a message when entering an amount. The entered amount is added to the total dollar value of the order. It will not add to the A/R when invoiced.
Ship Via Ship Date	The way order is scheduled to be shipped.
Truck Route	The truck route consists of three two-character fields; Truck Route, Stop#, and Run#.
Printer	Enter a printer code, such as P2 or P9. When applicable, the Floor Plan Company Name appears to the left of the Printer field.

Click Update to save any changes but not release the order from credit hold.

Click Release to save any changes and release the order from credit hold.

When orders are released from credit hold, an entry is made in the Order Details portion of the Order's notepad.

The Reports link in the upper right hand corner provides access to all the Navigator reports. There are several AR reports that might be useful when researching credit issues.